Show All
Direction
property as it applies to the ChErrorBars object.
Returns or sets the error-bar direction for the specified error bars. Read/write ChartErrorBarDirectionEnum.
| ChartErrorBarDirectionEnum can be one of these ChartErrorBarDirectionEnum constants. |
| chErrorBarDirectionX |
| chErrorBarDirectionY |
expression.Direction
expression Required. An expression that returns one of the above objects.
You can use the chErrorBarDirectionX constant only in xy (scatter), polar, bar, or bubble charts.
Direction
property as it applies to the SchemaParameter object.
Returns the Direction parameter for the SchemaRowSource object. Read-only ParameterDirectionEnum (ADO).
expression.Direction
expression Required. An expression that returns one of the above objects.
As it applies to
the ChErrorBars object.
This example adds error bars to the specified chart and sets the error-bar direction. Charts(0) must refer to an xy
(scatter), polar, bar, or bubble chart.
Sub AddErrorBars()
Dim ebErrorBars
Dim chConstants
Set chConstants = Chartspace1.Constants
' Add error bars to the first series in the chart.
Set ebErrorBars = ChartSpace1.Charts(0).SeriesCollection(0).ErrorBarsCollection.Add
' Set the direction of the error bars.
ebErrorBars.Direction = chConstants.chErrorBarDirectionX
End Sub